package com.kc.data.common.mapper;



import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.kc.data.common.domain.model.BizScenic;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BizScenicMapper extends BaseMapper<BizScenic> {
    /**
     * 查询景区
     * @param bizScenic 查询条件：支持景区名称，景区状态
     * @return 景区信息
     */
    List<BizScenic> selectList(BizScenic bizScenic);

    @Select("SELECT id,scenic_name,scenic_img,scenic_video_img,scenic_video,longitude,latitude,province,city,city_name,`area`,scenic_type,scenic_address,scenic_describe,sort,`status`,\n" +
            "is_recommend,is_face,`level`,score,start_time,end_time,`explain`,`describe`,service_item,describe_img,service_item_img,notice,is_deleted,create_by,create_time,update_by,update_time,tenant_id,\n" +
            "user_id,image_attr,ticket_scenic_id,adcode,is_personal_info_perfected,goods_id,sub_mchid FROM kc_scenic WHERE id=#{scenicId}")
    BizScenic getInfoById(Integer scenicId);
}
